package com.project.reggie.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.project.reggie.common.CustomException;
import com.project.reggie.dto.SetmealDto;
import com.project.reggie.entity.Dish;
import com.project.reggie.entity.Setmeal;
import com.project.reggie.entity.SetmealDish;
import com.project.reggie.mapper.SetmealMapper;
import com.project.reggie.service.SetmealDishService;
import com.project.reggie.service.SetmealService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
public class SetmealServiceImpl extends ServiceImpl<SetmealMapper,Setmeal> implements SetmealService {
    @Autowired
    private SetmealDishService setmealDishService;

    @Transactional
    public void saveWithDish(SetmealDto setmealDto) {
        //保存套餐的基本信息，操作setmeal 执行insert操作
        this.save(setmealDto);
        Long setmealId = setmealDto.getId();
        //保存套餐和菜品的关联信息，操作setmeal_dish 执行insert操作
        List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();
        for (SetmealDish item: setmealDishes ) {
            item.setSetmealId(setmealId);
        }
        setmealDishService.saveBatch(setmealDishes);

    }

    /**
     * 删除套餐 同时需要删除套餐和套餐的关联数据
     * @param ids
     */
    @Transactional
    public void removeWithDish(List<Long> ids){
        //select count(*) from setmeal where id in(1,2,3) and status = 1
        //查询套餐状态，确定是否可用删除
        LambdaQueryWrapper<Setmeal> queryWrapper=new LambdaQueryWrapper<>();
        queryWrapper.in(Setmeal::getId,ids);
        queryWrapper.eq(Setmeal::getStatus,1);

        int count = this.count(queryWrapper);
        if(count>0){
            //如果不能删除，抛出一个业务异常
            throw new CustomException("套餐正在售卖中，不能删除！");
        }
        //如果可以删除，先删除套餐表中的数据
        this.removeByIds(ids);

        //传过来的ids是套餐id  不是setmeal_dish中的主键
        //delete from sermeal_dish where sermeal_id in(1,2,3)
        LambdaQueryWrapper<SetmealDish> lambdaQueryWrapper=new LambdaQueryWrapper();
        lambdaQueryWrapper.in(SetmealDish::getSetmealId,ids);
        //删除关系表中的数据  setmeal_dish
        setmealDishService.remove(lambdaQueryWrapper);

    }
}
